﻿-- =============================================
-- Author:		Jhonatan Christian Belmontes Morales
-- Create date: 19/03/2012
-- Description:	Elimina procedencias
-- =============================================
CREATE PROCEDURE [dbo].[spEliminaProcedencia]
    (
      @pnIdProcedencia INT ,
      @pnIdLaboratorio INT ,
      @pnIdSucursal INT 
    )
AS 
    BEGIN

        SET NOCOUNT ON ;

        DELETE  FROM dbo.CatProcedencia
        WHERE   IdProcedencia = @pnIdProcedencia
                AND IdLaboratorio = @pnIdLaboratorio
                AND IdSucursal = @pnIdSucursal
	
        SET NOCOUNT OFF ;

    END